Sorting and grouping information

You can group either by sorting data, so that records with like data appear grouped in the sorted list, or by summarizing data with aggregate functions, so that summary data appears in your query for each group of records.

To group by sorting data
  1. From the Database Fields area of the Sort tab, select the field you want to sort.
  2. Click Add.

    The field is added to the Group Fields area.

  3. From the Order drop-down list, choose the order in which you want the data sorted.
  4. Repeat these steps for each field as required.
  5. Click Next. The Select tab appears.


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com